﻿CREATE TABLE [dbo].[t_CreditLiability] (
    [ID]                         INT           IDENTITY (1, 1) NOT NULL,
    [BorrowerID]                 INT           NULL,
    [CoBorrowerID]               INT           NULL,
    [CreditLiabilityID]          VARCHAR (128) NULL,
    [CreditFileID]               VARCHAR (128) NULL,
    [_AccountIdentifier]         BIGINT        NULL,
    [_AccountOpenedDate]         SMALLDATETIME NULL,
    [_AccountOwnershipType]      VARCHAR (128) NULL,
    [_AccountReportedDate]       SMALLDATETIME NULL,
    [_AccountStatusType]         VARCHAR (128) NULL,
    [_AccountType]               VARCHAR (128) NULL,
    [_CreditLimitAmount]         INT           NULL,
    [_DerogatoryDataIndicator]   CHAR (1)      NULL,
    [_HighCreditAmount]          INT           NULL,
    [_LastActivityDate]          SMALLDATETIME NULL,
    [_MonthlyPaymentAmount]      SMALLINT      NULL,
    [_TermsSourceType]           VARCHAR (128) NULL,
    [_MonthsReviewedCount]       TINYINT       NULL,
    [_OriginalCreditorName]      VARCHAR (128) NULL,
    [_PastDueAmount]             SMALLINT      NULL,
    [_TermsDescription]          VARCHAR (128) NULL,
    [_UnpaidBalanceAmount]       INT           NULL,
    [CreditLoanType]             VARCHAR (128) NULL,
    [_CURRENT_RATING_Code]       TINYINT       NULL,
    [_30Days]                    TINYINT       NULL,
    [_60Days]                    TINYINT       NULL,
    [_90Days]                    TINYINT       NULL,
    [_120Days]                   TINYINT       NULL,
    [_PAYMENT_PATTERN_Data]      VARCHAR (128) NULL,
    [_PAYMENT_PATTERN_StartDate] SMALLDATETIME NULL,
    [CREDIT_COMMENT]             VARCHAR (512) NULL,
    [DTI]                        BIT           NOT NULL,
    [Ghost]                      BIT           NOT NULL
);

